﻿CREATE TABLE [flcrTM].[DEVICE_DEPENDENT] (
    [TM_DEVICE_DEPENDENT_ID] INT          IDENTITY (1, 1) NOT NULL,
    [TIME_KEY]               INT          NOT NULL,
    [DEVICE_DEPENDENT_ID]    INT          NOT NULL,
    [AUDIT_USER]             VARCHAR (50) NOT NULL,
    [AUDIT_DTTM]             DATETIME     NOT NULL,
    [AUDIT_DTTM_TZ]          INT          NOT NULL,
    [AUDIT_MOD_USER]         VARCHAR (50) NOT NULL,
    [AUDIT_MOD_DTTM]         DATETIME     NOT NULL,
    [AUDIT_MOD_DTTM_TZ]      INT          NOT NULL,
    [ACTIVE_FLG]             BIT          NOT NULL,
    [DEVICE_ID]              INT          NOT NULL,
    [DEVICE_ID_DEPD]         INT          NOT NULL,
    [DEVICE_PROP_TYPE]       INT          NOT NULL
);

